﻿/* <Test data> */
/* <Permissions> */
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'8274825f-2c48-7bc1-3a98-035fb68b8eeb', N'ResponsibleWaitingList', N'قائمة انتظار المسئول')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'f53ca3af-fffe-2c9e-bebc-05765cc8f11b', N'CreateBoard', N'انشاء لجنة')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'25bf376c-9df0-faa0-e8d2-0fcefaa7ce95', N'CreateCustomer', N'عميل جديد')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'57cde897-af61-d89d-d54b-13f41476a4f4', N'CreateLoan', N'قرض جديد')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) Values (N'1d8f5176-a6f3-f904-e784-11dd54c6115b', N'NewLoanList', N'تاكيد القروض الجديدة') 
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'55c469d6-c159-e352-d4e2-15c7037f816a', N'CustomerHistory', N'تاريخ العملاء')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'24aeb638-3bb8-78f2-3b75-1d93c3fdd408', N'ExpertWaitingList', N'قائمة انتظار الخبير')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'02cc793e-c35b-6489-2b03-2bd0672d30b7', N'FeasibilityStudy', N'دراسات الجدوى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'b593299f-3ab3-e828-564e-320786898237', N'LoanSocialResearchDetails', N'تفاصيل البحث الاجتماعى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'4d031e5c-d313-ab10-bdf9-3bfe8ab7f871', N'CommitteesList', N'الجمعيات')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'76ec4592-808c-5205-d528-3dbee2b5c32d', N'LookUpManager', N'الجداول')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'34735921-09ee-a978-1439-47354fabebdd', N'ProjectDetails', N'تفاصيل المشروع')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'eb10d0a1-8db6-2c84-7c7a-4f24a44fe670', N'ProjectList', N'قائمة المشاريع')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'caba8b3d-abc2-db82-c529-52f7d9604afa', N'Settings', N'الاعدادات')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'0199bc89-5b9f-2c88-1d30-55d05e8ccbcc', N'VillageDetails', N'تفاصيل قريه')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'6eee56ab-1ce2-23f6-77a2-5e2bbad54a4a', N'VillageList', N'قائمة القرى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'abbafa5e-51f1-2259-7920-6dd720871c17', N'RoleDetails', N'تفاصيل وظيفة')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'6a052a44-4f30-5cc8-b3fd-6e4a4e6dbe06', N'RolesList', N'قائمة الوظائف')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'33c1aa4a-d8e4-e48b-7e44-6ecbf0d167c6', N'UserDetails', N'تفاصيل مستخدم')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'9a68d387-3a4c-46d0-962e-7089af032125', N'UsersList', N'قائمة المستخدمين')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'260dbccb-68b5-dc0f-97fe-7b359742ffbd', N'SaveExpertWaitingList', N'حفظ قائمة انتظار الخبير')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'ecfd3089-a36d-4100-d48d-7d9e8afe6e16', N'SaveCommitteeList', N'حفظ قائمة اللجان')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'd345273d-a452-584b-78f5-7e2355662b16', N'SaveLookupManager', N'حفط جداول البحث')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES(N'65161bf9-6a9d-ff3d-2dd3-8f9bbf235433', N'SubmitProjectDetails', N'حفظ بيانات المشروع')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'fdac8c45-26b5-8569-e0f9-94936f40b7d8', N'SaveSettings', N'حفظ الاعدادات')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'e12bdfea-cea5-c8c4-c524-97be40a7e508', N'SubmitCreateBoard', N'حفظ لجنه')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'30042612-3f5b-dca6-40b7-9b48a9362038', N'AddCustomer', N'حفظ عميل')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'ea3074f8-5719-b57b-f3a8-9ee432edb766', N'AddLoan', N'حفظ قرض')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'ab089e7b-4c66-e5de-4b1e-a05ea58d3b82', N'AcceptFeasibilityStudy', N'الموافقة على دراسة الجدوى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'835637ff-bdd6-67f0-14fc-a478e61ac206', N'RefuseFeasibilityStudy', N'رفض دراسة الجدوى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'72c2ca42-880c-98bf-3749-a7099ccb5448', N'AcceptSocialResearch', N'حفظ البحث الاجتماعى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'0386ecec-9d6d-a6e8-e30d-a8d15a5d5923', N'RefuseSocialResearch', N'رفض البحث الاجتماعى')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'13906bab-0388-03b8-f4b0-ae1441fadfd2', N'RefuseLoanByReponsible', N'رفض القرض من المسئول')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'99f6f88b-dd8b-0603-29df-af8f4a69d265', N'DeleteProject', N'حذف مشروع')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'77a5dda5-8c02-5f7c-6f56-afe242cb880e', N'AddEditRole', N'اضافة و تعديل وظيفة')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'aec05ec4-409e-b8c7-6a75-b64eaf5b4857', N'AddEditUser', N'اضافة و تعديل مستخدم')
INSERT [Permissions] ([PermissionID], [PermissionName], [PermissionArabicName]) VALUES (N'cba02682-76e7-73b5-2261-b9b8acefc297', N'SaveUploadImageControl', N'حفظ صورة')
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '65971178-dedb-bcfb-a8e7-4c0ae00b9412' , N'BoardMom', N'محاضر اللجان') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '51ded59d-5f03-bbf8-8e34-51b6ad6bd3b0' , N'CEOWaitingList', N'قائمة إنتظار مدير عام الإتحاد') 
INSERT INTO [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'ab99c510-6864-58ad-1988-b2bdbca4fd5b' , N'Synch', N'التزامن') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '1e80e96b-9bab-7b99-9cda-e548c8a1c279' , N'ReviewerWaitingList', N'قائمة انتظار المراجع') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'f0ac93d8-63d5-4e7a-90d9-2405ac671bcf' , N'ResearchAndStudy', N'بحث و دراسة') 
--INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'bce1fb10-d1e0-4213-9028-c2b7f558c1c7' , N'ImagesSearch', N'البحث عن الصور') 

INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'D1CDB5DE-13A5-4542-AFCB-16FA209AA8E7' , N'AssociationDues', N'قائمة مستحقات الجمعية') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '4CE1B8A0-1EC9-4FEB-8615-2752FF5B556A' , N'AssociationExpenses', N'قائمة مصاريف الجمعية') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'C1468B6E-A42F-467D-8A17-F23D5DEC761A' , N'AssociationsBankAccounts', N'قائمه حسابات البنوك') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '14AC7791-C7F2-4A3A-ACCA-7979727281D1' , N'CancelLoanDebts', N'اسقاط دين القرض ') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '0AB1807D-1895-4489-B186-5BBE97D929BB' , N'ClientProsecution', N'مقاضاه العميل') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '639D5D7D-619A-4404-BA21-36EE27592441' , N'FreezLoansView', N' القروض المؤجله') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'EAC7BD78-1F20-4347-BF6C-A01E073F0D5A' , N'InstallmentsPayment', N'قائمة دفع الاقساط') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '68F2821D-8339-4C08-B399-EAD2529775B8' , N'InstallmentWarningList', N'قائمة الانذارات') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '826B35E6-6ECF-4F74-91E4-10E832820876' , N'LoanCasesList', N'قائمة مقائات القروض') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '834C54EC-C226-484A-AAD1-461409FCFD2C' , N'LoanRescheduling', N'اعادة جدوله القرض') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'AB03DC82-DDBE-47E0-A069-7F88739EA2F8' , N'MainCommitteeDeposite', N'ايداعات الاتحاد') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '68BA9149-B1B5-42A8-800B-F253399048CD' , N'MainCommitteeExpense', N'مصاريف الاتحاد') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '4D9273ED-D6BA-4768-9791-AE2BE456A2DA' , N'StumbledLoans', N'قروض متعذرة السداد') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'CFAB66E6-669D-42DF-B32D-7E69C8FA1EF8' , N'TodaySammary', N'احداث اليوم') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( 'AC3FD9B2-7E1C-4D03-8CC8-651B5CC5CEBE' , N'UnionDepositAssociation', N'تحويل لجمعية') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '6FA0AB94-48A3-4DC5-8483-4507CFA5FC26' , N'AssociationBankDeposite', N'ايداعات الجمعية في البنك') 
INSERT [Permissions] ( [PermissionID] , [PermissionName], [PermissionArabicName]) Values( '1B30AF84-7BC3-48FD-8DC9-7D0A95817085' , N'AssociationDeposites', N'ايداعات الجمعية') 
/* </Permissions> */           
           
INSERT INTO dbo.Governorates (GovernorateID, GovernorateName)
	VALUES ('00000000-0000-0000-1111-000000000000', N'Test Governorate' ) 

INSERT INTO dbo.Centers (CenterID, CenterName, GovernorateID)
	VALUES ('00000000-0000-0000-1111-000000000000', N'Test Center', '00000000-0000-0000-1111-000000000000' )
	
INSERT INTO [dbo].[IssuePlace]([IssuePlaceID] ,[IssuePlaceName] ,[CenterID])
     VALUES
           ('FDEF6707-FEC4-4B56-85F3-1CAC1EA87C39', N'Test IssuePlace', '00000000-0000-0000-1111-000000000000')
	
INSERT INTO [dbo].[Villages]([VillageID] ,[VillageName] ,[CenterID])
     VALUES ('00000000-0000-0000-1111-000000000000', 'Test Village', '00000000-0000-0000-1111-000000000000')


	



/* <LookUps> */
INSERT INTO [dbo].[LoanLegalForms]([LegalFormID],[LegalFormName])
     VALUES('47062B83-8C39-4BAD-BA99-66A5A88F630B', N'فردية')
     
INSERT INTO [dbo].[LoanLegalForms]([LegalFormID],[LegalFormName])
     VALUES('F0601FC7-EE38-4729-A325-D7823308072E', N'شركة')
           
INSERT INTO [EducationalLevels] ( [EducationalLevelID] , [EducationalLevelName]) 
	Values('F78FBC4C-4FBB-4EE9-BB5C-E686E2283CA6' , N'غير متعلم') 
GO

INSERT INTO [EducationalLevels] ( [EducationalLevelID] , [EducationalLevelName]) 
	Values('CF34C4E7-6C6E-4929-A70C-E5D80A252054' , N'تعليم متوسط') 
GO

INSERT INTO [EducationalLevels] ( [EducationalLevelID] , [EducationalLevelName]) 
	Values('AA21FECB-7C3B-453F-87DF-FBC583E8B9BC' , N'تعليم عالى') 
GO

INSERT INTO [dbo].[LoanPaymentMethod]
           ([LoanPaymentMethodID]
           ,[LoanPaymentMethodName]
           ,[MonthlyPenaltyPercent]
           ,[LastMonthPenaltyPercent])
     VALUES
           ('5CA0FB45-6F1B-4992-B2E4-098ECEFCA74F'
           ,N'دورى', 1, 1)
GO

INSERT INTO [dbo].[LoanPaymentMethod]
           ([LoanPaymentMethodID]
           ,[LoanPaymentMethodName]
           ,[MonthlyPenaltyPercent]
           ,[LastMonthPenaltyPercent])
     VALUES
           ('C0353375-EB6B-4799-8043-DDAB293CB206'
           ,N'فترة سماح', 10, 0.25)
GO

INSERT INTO [LoanPlaceTypes] ( [LoanPlaceID] , [LoanPlaceName]) 
	Values('826C3B2F-7493-4551-AF00-C4A5D6EC9CAC' , N'ملك') 
GO

INSERT INTO [LoanPlaceTypes] ( [LoanPlaceID] , [LoanPlaceName]) 
	Values('826C3B2F-7493-4551-AF00-C4A5D6EC9C00' , N'ايجار') 
GO

INSERT INTO [LoanPlaceTypes] ( [LoanPlaceID] , [LoanPlaceName]) 
	Values('8A2F0534-DF00-4DE4-8F25-8AA571F46A1F' , N'منزلى') 
GO

INSERT INTO [LoanPlaceTypes] ( [LoanPlaceID] , [LoanPlaceName]) 
	Values('8A2F0534-DFDA-4DE4-8F25-8AA571F46A1F' , N'خارج المنزل') 
GO

INSERT INTO [LoanType] ( [LoanTypeID] , [LoanTypeName])
	Values( '826C3B2F-7493-4551-AF00-C4A5D6EC00AC', N'زراعى')
GO

INSERT INTO [LoanType] ( [LoanTypeID] , [LoanTypeName])
	Values( '826C3B2F-7493-4551-AF00-00A5D6EC9CAC', N'صناعى') 
GO

INSERT INTO [MilitaryStatuses] ( [MilitaryStatusID] , [MilitaryStatusName]) 
	Values('826C3B2F-7493-4551-0000-C4A5D6EC9CAC' , N'مؤجل') 
GO

INSERT INTO [MilitaryStatuses] ( [MilitaryStatusID] , [MilitaryStatusName]) 
	Values('006C3B2F-7493-4551-AF00-C4A5D6EC9CAC' , N'معفى') 
GO

INSERT INTO [MilitaryStatuses] ( [MilitaryStatusID] , [MilitaryStatusName]) 
	Values('3D3B7C7D-0391-4559-9895-8076EED2DD3F' , N'ادى الخدمة') 
GO

INSERT INTO [SocialStatuses] ( [SocialStatusID] , [SocialStatusName]) 
	Values('826C3B2F-0093-4551-AF00-C4A5D6EC9CAC' , N'أعزب') 
GO

INSERT INTO [SocialStatuses] ( [SocialStatusID] , [SocialStatusName]) 
	Values('826C3B2F-7400-4551-AF00-C4A5D6EC9CAC', N'متزوج') 
GO

INSERT INTO [SocialStatuses] ( [SocialStatusID] , [SocialStatusName]) 
	Values('E856ACC1-F7A9-4201-B232-EF3855460235', N'ارمل') 
GO

INSERT INTO [SocialStatuses] ( [SocialStatusID] , [SocialStatusName]) 
	Values('E44CA398-B820-45A5-AA55-E655110611B8', N'مطلق') 
GO

INSERT INTO [dbo].[ImageTypes] ([ImageTypeID] ,[ImageTypeName])
	VALUES ('6E4E4FFC-7D00-4E08-9808-42F5BF59BFF9' ,N'صورة شيك')

INSERT INTO [dbo].[ImageTypes] ([ImageTypeID] ,[ImageTypeName])
	VALUES ('6E4E4FFC-7D89-0008-9808-42F5BF59BFF9' ,N'صورة بطاقة')
	
INSERT INTO [dbo].[ImageTypes] ([ImageTypeID] ,[ImageTypeName])
	VALUES ('6E4E4FFC-7D89-0008-9808-42BBBF59BFF9' ,N'صورة عقد')
	
INSERT INTO [dbo].[ImageTypes] ([ImageTypeID] ,[ImageTypeName])
	VALUES ('6E4E4FFC-7D89-0008-9866-42F5BF59BFF9' ,N'صورة شهادة ميلاد')
	
INSERT INTO [dbo].[ReceiptType]([ReceiptTypeID], [ReceiptTypeName])
	VALUES('F4D1689C-5B4A-4A0F-ADD1-8A0BFD744A3D', N'ايصال طلب قرض')
	
INSERT INTO [dbo].[ReceiptType]([ReceiptTypeID], [ReceiptTypeName])
	VALUES('2852D9B2-5FC3-4880-AD4B-911E070CF7AD', N'ايصال دفع قسط')
	
INSERT INTO [dbo].[ReceiptType]([ReceiptTypeID], [ReceiptTypeName])
	VALUES('4D33B3D0-F1EA-473C-B1D1-FC5F036FFF15', N'صورة البحث الاجتماعى')

INSERT INTO [dbo].[ReceiptType]([ReceiptTypeID], [ReceiptTypeName])
	VALUES('30242AB0-986C-4A9C-A19E-C37F97307708', N'صورة دراسة الجدوى')

INSERT INTO [dbo].[ReceiptType]([ReceiptTypeID], [ReceiptTypeName])
	VALUES('93DE3D0E-1220-4BAC-9C04-11CAA68BF141', N'صورة محضر اللجنة')
	
           
INSERT INTO [dbo].[LoanHistoryCloseType]([LoanHistoryCloseTypeID],[LoanHistoryCloseTypeName])
     VALUES('0407fd60-846f-a72e-42aa-029c9f70a6be', N'محاكمة ')
     
     INSERT INTO [dbo].[LoanHistoryCloseType]([LoanHistoryCloseTypeID],[LoanHistoryCloseTypeName])
     VALUES('ba51aeba-8180-3491-a982-e929e8ff5af7', N'إعدام الدين')
     
      INSERT INTO [dbo].[LoanHistoryCloseType]([LoanHistoryCloseTypeID],[LoanHistoryCloseTypeName])
     VALUES('31AB609F-88B4-4686-8F53-24FCE9FD4723', N'إعادة جدولة')
     
     INSERT INTO [dbo].[LoanHistoryCloseType]([LoanHistoryCloseTypeID],[LoanHistoryCloseTypeName])
     VALUES('7ad37c79-2474-b5fe-ea36-c36369d95883', N'تم التنفيذ بنجاح')
     
/* </LookUps> */

/* </Testdata> */

/* begin test Workflow  */


INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '01bb53ca-1823-1149-6308-08c6ece1dd9a' , N'Accept' , N'موافقة' , N'موافقة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'c825c01e-6018-c4cb-108e-1466e4cc2bae' , N'Skip' , N'تخطي' , N'تخطي') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '69e8ecf1-c261-71b1-93e7-15aaa282953c' , N'Procecute' , N'مقاضاة' , N'مقاضاة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '7a3dcb1c-c5be-2f35-7823-18bf6f319e68' , N'CancelPenalties' , N'الغاء الغرامات' , N'الغاء الغرامات') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '3bad2fae-3c62-c154-ec31-260aca17de29' , N'Close' , N'إغلاق' , N'إغلاق') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , N'Return' , N'عودة' , N'عودة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '285be8ce-3387-6df0-0f25-742cc06bee23' , N'Freez Without Research & Study' , N'تجميد بدون بحث و دراسة' , N'تجميد بدون بحث و دراسة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'c758debe-cc91-d6bc-b2c0-7c8608bb0132' , N'Unfreeze' , N'استكمال' , N'استكمال') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '1589e228-05be-4bbd-4e9c-83a976de207a' , N'Stumble' , N'تعثر' , N'تعثر') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '8ca482b5-50db-23e4-961f-8d0039070a78' , N'Create' , N'انشاء' , N'انشاء') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'bb26ab43-f3ab-81c8-eb89-9b4ad36f64cf' , N'Ask For Old Date' , N'طلب تاريخ قديم' , N'طلب تاريخ قديم') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , N'Refuse' , N'رفض' , N'رفض') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '2fa9f8ac-2b6b-c8d8-d798-a14d87ac7864' , N'Freeze' , N'تأجيل' , N'تأجيل') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '6d6594fd-35d4-aabe-1baa-bd3226787d04' , N'Freez With Research and Study' , N'تجميد مع بحث و دراسة' , N'تجميد مع بحث و دراسة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , N'Submit' , N'ارسال' , N'ارسال') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'a6b1db3e-a7f9-b61e-c015-ed23972ccc18' , N'Reschedule' , N'إعادة جدولة' , N'إعادة جدولة') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '209aa42e-9050-7088-a66f-d6f0cf98e486' , N'Pay Debts' , N'دفع كل الديون' , N'دفع كل الديون') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( '20aab6cc-59d4-a250-db47-f51c141f52f9' , N'Cancel Debts' , N'إلغاء الديون' , N'إلغاء الديون') 
GO

INSERT INTO [wfActionTypes] ( [ActionTypeID] , [ActionName] , [DisplayName] , [Description]) Values( 'e8bb62bf-44fd-2fa8-d684-9bb39d27c2a4' , N'Refused From Begining' , N'رفض من البداية' , N'رفض من البداية') 
GO





INSERT INTO [wfProcesses] ( [ProcessID] , [ProcessName] , [Description]) Values( '480d1cad-7c6b-bce0-1150-f6063cec9776' , N'دورة القرض' , N'الدورة الكاملة لانشاء قرض') 
GO

INSERT INTO [wfProcesses] ( [ProcessID] , [ProcessName] , [Description]) Values( '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , N'دورة اللجنة' , N'هذه لانشاء دورة جديدة للجنة') 
GO



INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '3aed9b30-e2a1-99db-4f6a-3d503c208f65' , N'صراف الجمعية') 
GO

INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '672bdd8f-71ff-6288-6c8b-554ba481ac32' , N'مدير عام الاتحاد') 
GO

INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '456052c6-9f8c-a1de-34bd-687e4969db87' , N'محاسب الجمعية') 
GO

INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '0cd962c7-2edd-0e22-3f84-73321d43f338' , N'مسئول ميدانى') 
GO

INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '7b4cdd4a-d9c3-8e0f-7de5-afabbd6ca163' , N'خبير') 
GO

INSERT INTO [Roles] ( [RoleID] , [RoleName]) Values( '88c71a15-9f86-822b-6b52-b4619d20aff0' , N'مراجع الاتحاد') 
GO




INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '232b7945-a02a-fa1b-2195-0fad61736b90' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Research and Study' , N'بحث و دراسة' , N'بحث و دراسة' , 1 , 1 , 'True' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '8da4d055-5b39-3924-23df-1b6d5efa082a' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Board List' , N'قائمة اللجنة' , N'قائمة اللجنة' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'bb7dbfdb-817f-2736-d69d-1f058e532998' , '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , 'Borad CEO List' , N'قائمة انتظار اعتماد المدير للجان' , N'قائمة انتظار اعتماد المدير للجان' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'b814b33d-db46-2142-f9cc-516ca934c6db' , '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , 'Board Review List' , N'قائمة انتظار مراجع اللجان' , N'قائمة انتظار مراجع اللجان' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '69e4e5aa-1317-9b5e-0b8b-5417971a9411' , '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , 'Board Closed List' , N'قائمة اللجان المغلقة' , N'قائمة اللجان المغلقة' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '1a4d3cdd-14ac-4f75-077d-65c4a7c6705d' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Reviewer Execution OldDate Approve' , N'اعتماد المراجع للتنفيذ بتاريخ قديم' , N'اعتماد المراجع للتنفيذ بتاريخ قديم' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '411adcf8-19af-8c41-c71c-713b3deaa2cb' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Refused Execution List' , N'القروض المرفوض تنفيذها' , N'القروض المرفوض تنفيذها' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'c15f20cc-0571-4770-4566-89d72424c719' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Reviewer Payment OldDate Approve' , N'اعتماد المراجع للدفع يتاريخ قديم' , N'اعتماد المراجع للدفع يتاريخ قديم' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Board Waiting List' , N'انتظار لجنة' , N'انتظار لجنة' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '7fad7dce-520e-9689-83dc-940662ab7db4' , '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , 'Board Mom' , N'فى انتظار محضر اللجنة' , N'فى انتظار محضر اللجنة' , 1 , 1 , 'True' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'f09e9178-619d-98f1-d563-a1bb3dda4941' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Execution waiting list' , N'قائمة القروض المنتظرة التنفيذ' , N'قائمة القروض المنتظرة التنفيذ' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '704fb001-5427-6f45-db04-b69767feafa8' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Review List' , N'قائمة المراجع' , N'قائمة المراجع' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Ended Loans' , N'القروض المنتهية' , N'القروض المنتهية' , 1 , 1 , 'False' , 'True') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'eaac13c0-6dc1-73b9-c20e-cd234fd21f8b' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Refused Loans' , N'القروض المرفوضة' , N'القروض المرفوضة' , 1 , 1 , 'False' , 'True') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '60c356a0-a65d-804a-6f03-d40a55d6150f' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Postpone List without Research and Study' , N'قائمة المؤجلين بدون إعادة البحث والدراسة' , N'قائمة المؤجلين بدون إعادة البحث والدراسة' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '9733befa-94ff-9c85-9035-da3cd6054d67' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Postpone List with Research and Study' , N'قائمة المؤجلين مع إعادة البحث والدراسة' , N'قائمة المؤجلين مع إعادة البحث والدراسة' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '0c68bd59-7f9d-c0b9-4e12-e5dc5bb38e7c' , '3a5c8259-7e61-61c7-d1ae-6d734a19a566' , 'Board Execution List' , N'قائمة تنفيذ اللجان' , N'قائمة تنفيذ اللجان' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '402eb3fa-acf0-56ec-be8f-e78d7be5824c' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Payment List' , N'دفع القرض' , N'دفع القرض' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '86a7affa-cc1c-396b-8134-ea6a5b969205' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'CEO List' , N'مدير عام الاتحاد' , N'مدير عام الاتحاد' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Expert Waiting List' , N'قائمة الخبير' , N'قائمة الخبير' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'b3435a53-b69b-3f0f-4a00-f4914f17c4df' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Loan Created' , N'أنشاء قرض' , N'أنشاء قرض' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( '1763c4e4-2ba7-dc72-4b04-5a8b273dbb6b' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Prosecution' , N'مقضاة العميل' , N'مقضاة العميل' , 1 , 1 , 'False' , 'False') 
GO

INSERT INTO [wfSteps] ( [StepID] , [ProcessID] , [StepName] , [DisplayName] , [Description] , [OverdueAfter] , [ExpireAfter] , [IsFirstStep] , [IsLastStep]) Values( 'd32c9d80-1824-15f5-3476-c01e2471a0b3' , '480d1cad-7c6b-bce0-1150-f6063cec9776' , 'Stumbled Payment Loans' , N'تعثر السداد' , N'تعثر السداد' , 1 , 1 , 'False' , 'False') 
GO




INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'dc766a94-2214-c857-f2f9-0fe99c8e37fe' , 'a6b1db3e-a7f9-b61e-c015-ed23972ccc18' , 'd32c9d80-1824-15f5-3476-c01e2471a0b3' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'a934be37-2e6f-be68-260d-1342b191f74c' , '2fa9f8ac-2b6b-c8d8-d798-a14d87ac7864' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '9733befa-94ff-9c85-9035-da3cd6054d67') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '0a21c781-df7a-5fe0-b16c-13c7403ec409' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '185e64dc-94ec-bb67-3f03-16e6eee6bd82' , '2fa9f8ac-2b6b-c8d8-d798-a14d87ac7864' , '232b7945-a02a-fa1b-2195-0fad61736b90' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '3fed2106-aaaf-76f3-565b-1fe121efa942' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , 'c15f20cc-0571-4770-4566-89d72424c719' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '15c0fe4e-25b9-5cf6-596a-209705cf0e0b' , 'bb26ab43-f3ab-81c8-eb89-9b4ad36f64cf' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c' , 'c15f20cc-0571-4770-4566-89d72424c719') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '20097e7d-47e4-1658-015f-22e5ac2556c4' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , '232b7945-a02a-fa1b-2195-0fad61736b90' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'a3d348ed-bd0c-c68c-6f10-26e80dc1f17f' , 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , '86a7affa-cc1c-396b-8134-ea6a5b969205' , '704fb001-5427-6f45-db04-b69767feafa8') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'b07f1b8f-e07f-dcff-28f5-30bdf54c4789' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , '1a4d3cdd-14ac-4f75-077d-65c4a7c6705d' , 'f09e9178-619d-98f1-d563-a1bb3dda4941') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '7cc18ccf-06e4-4d53-9538-31ab57bb9e90' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'e7d2ffed-2c90-6814-14e1-325a563146b8' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '8da4d055-5b39-3924-23df-1b6d5efa082a' , '704fb001-5427-6f45-db04-b69767feafa8') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '8d7b7fce-ae62-622e-4264-32d3056cc822' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , 'f09e9178-619d-98f1-d563-a1bb3dda4941' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'eb6295c3-c584-6f5a-4d71-39f6e10e1446' , 'bb26ab43-f3ab-81c8-eb89-9b4ad36f64cf' , 'f09e9178-619d-98f1-d563-a1bb3dda4941' , '1a4d3cdd-14ac-4f75-077d-65c4a7c6705d') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'b442ff77-a929-79c4-ae4b-418ca310067d' , '69e8ecf1-c261-71b1-93e7-15aaa282953c' , 'd32c9d80-1824-15f5-3476-c01e2471a0b3' , '1763c4e4-2ba7-dc72-4b04-5a8b273dbb6b') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'eabd797a-de75-4913-8618-457c3adb3778' , 'c758debe-cc91-d6bc-b2c0-7c8608bb0132' , '60c356a0-a65d-804a-6f03-d40a55d6150f' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '39ea7e53-0007-faaa-df42-4c4d95693c15' , '6d6594fd-35d4-aabe-1baa-bd3226787d04' , '86a7affa-cc1c-396b-8134-ea6a5b969205' , '9733befa-94ff-9c85-9035-da3cd6054d67') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'dbf76579-e16f-7e9e-caa3-51fb64405be8' , '1589e228-05be-4bbd-4e9c-83a976de207a' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c' , 'd32c9d80-1824-15f5-3476-c01e2471a0b3') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'b4b46f05-5955-13a2-81c6-543139fa7d67' , 'c825c01e-6018-c4cb-108e-1466e4cc2bae' , '232b7945-a02a-fa1b-2195-0fad61736b90' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'd7fdac63-9c10-e702-5f6c-5be1a4e72639' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , 'b3435a53-b69b-3f0f-4a00-f4914f17c4df' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '0358814c-c44f-dfc2-5cc5-607c7c755ff4' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , '7fad7dce-520e-9689-83dc-940662ab7db4' , 'b814b33d-db46-2142-f9cc-516ca934c6db') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'dfe3aad6-2da7-339e-f75d-62bb3be11667' , '2fa9f8ac-2b6b-c8d8-d798-a14d87ac7864' , 'b3435a53-b69b-3f0f-4a00-f4914f17c4df' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '5380ffa0-ec2d-dccd-0f74-686792a3aab1' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , 'c15f20cc-0571-4770-4566-89d72424c719' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '4c8dec0c-d1b7-133d-6ca2-69481e273de4' , 'c758debe-cc91-d6bc-b2c0-7c8608bb0132' , '9733befa-94ff-9c85-9035-da3cd6054d67' , '232b7945-a02a-fa1b-2195-0fad61736b90') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '1a88a69c-4ef2-857c-98f0-6dbb3c719082' , '6d6594fd-35d4-aabe-1baa-bd3226787d04' , '8da4d055-5b39-3924-23df-1b6d5efa082a' , '704fb001-5427-6f45-db04-b69767feafa8') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '875e7886-bc2e-472d-6c7d-762a5110cf3c' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '1a4d3cdd-14ac-4f75-077d-65c4a7c6705d' , 'f09e9178-619d-98f1-d563-a1bb3dda4941') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'bc3f699e-73aa-e05b-7495-76f90056a875' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '232b7945-a02a-fa1b-2195-0fad61736b90' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '098ffdef-b002-e91a-3b14-7d08d7fddb58' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , 'bb7dbfdb-817f-2736-d69d-1f058e532998' , '0c68bd59-7f9d-c0b9-4e12-e5dc5bb38e7c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '42dfbcff-b771-e21c-a7c5-81bc5b3a3ee9' , 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , 'bb7dbfdb-817f-2736-d69d-1f058e532998' , 'b814b33d-db46-2142-f9cc-516ca934c6db') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '1934952f-36c2-8d83-47b1-8eafe45a9fef' , 'e8bb62bf-44fd-2fa8-d684-9bb39d27c2a4' , '232b7945-a02a-fa1b-2195-0fad61736b90' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'd48f4a23-d6fc-4670-9e8f-91d014b614b1' , '2fa9f8ac-2b6b-c8d8-d798-a14d87ac7864' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '18b915a0-abc5-2da9-af56-928758592d06' , '20aab6cc-59d4-a250-db47-f51c141f52f9' , '1763c4e4-2ba7-dc72-4b04-5a8b273dbb6b' , 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'c7c74b86-b8de-7323-d6e3-93450d625224' , '20aab6cc-59d4-a250-db47-f51c141f52f9' , 'd32c9d80-1824-15f5-3476-c01e2471a0b3' , 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '9e204402-3a94-e011-4b25-93c109b0c1ac' , 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , '704fb001-5427-6f45-db04-b69767feafa8' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '4be87e32-cd9f-878b-3777-9fdd1c871752' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '7954ee12-06b2-656c-2e6e-a2303a5aa9bf' , '285be8ce-3387-6df0-0f25-742cc06bee23' , '86a7affa-cc1c-396b-8134-ea6a5b969205' , '60c356a0-a65d-804a-6f03-d40a55d6150f') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'af364948-8a6a-6d06-f35e-a26c918f7bfa' , 'c825c01e-6018-c4cb-108e-1466e4cc2bae' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '71c57c8a-714d-e88f-b555-a925056a15ed' , '8ca482b5-50db-23e4-961f-8d0039070a78' , 'b3435a53-b69b-3f0f-4a00-f4914f17c4df' , '232b7945-a02a-fa1b-2195-0fad61736b90') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '99d6fd46-2c69-ba93-c563-a96e76ae7b7c' , '6d6594fd-35d4-aabe-1baa-bd3226787d04' , '704fb001-5427-6f45-db04-b69767feafa8' , '86a7affa-cc1c-396b-8134-ea6a5b969205') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'e31f56bc-8254-44f1-5352-aa00c47adf25' , 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , 'ee3c7498-f3a7-e3c5-ee4a-f2706c3dc488' , '232b7945-a02a-fa1b-2195-0fad61736b90') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '22b77ad2-40d1-b398-f5e4-ab5fa1852517' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , '86a7affa-cc1c-396b-8134-ea6a5b969205' , 'f09e9178-619d-98f1-d563-a1bb3dda4941') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'ada80a55-cb09-f1f6-b95b-ba9f70fa7704' , 'c4584f35-8f55-90a6-4706-51dcc75dbf98' , 'b814b33d-db46-2142-f9cc-516ca934c6db' , '7fad7dce-520e-9689-83dc-940662ab7db4') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'aaf6d6a9-1736-d088-647f-c51e7b443588' , '285be8ce-3387-6df0-0f25-742cc06bee23' , '704fb001-5427-6f45-db04-b69767feafa8' , '86a7affa-cc1c-396b-8134-ea6a5b969205') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'd688a55a-d6a6-5e43-1f6a-c6d7e2a68551' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , '704fb001-5427-6f45-db04-b69767feafa8' , '86a7affa-cc1c-396b-8134-ea6a5b969205') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '392002d7-df19-e210-020c-c74febcd7984' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '704fb001-5427-6f45-db04-b69767feafa8' , '86a7affa-cc1c-396b-8134-ea6a5b969205') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'fb68ef2e-7484-841c-2141-c91ca8ed7209' , '3bad2fae-3c62-c154-ec31-260aca17de29' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '36918938-c8a3-57b0-956e-d25cee9e40f3' , '01bb53ca-1823-1149-6308-08c6ece1dd9a' , '8da4d055-5b39-3924-23df-1b6d5efa082a' , '704fb001-5427-6f45-db04-b69767feafa8') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'cbd49ab8-2455-e530-3e5b-d3e8d3e38d06' , '7a3dcb1c-c5be-2f35-7823-18bf6f319e68' , 'd32c9d80-1824-15f5-3476-c01e2471a0b3' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '12fe3a02-5cc4-bf1c-2f04-d705b50a5a60' , '285be8ce-3387-6df0-0f25-742cc06bee23' , '8da4d055-5b39-3924-23df-1b6d5efa082a' , '704fb001-5427-6f45-db04-b69767feafa8') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'f342a07b-9390-ba5e-9964-da136ada573b' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , 'b814b33d-db46-2142-f9cc-516ca934c6db' , 'bb7dbfdb-817f-2736-d69d-1f058e532998') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '4a2cb42d-3053-4962-9c21-de6eafd818f0' , 'c825c01e-6018-c4cb-108e-1466e4cc2bae' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'c149d839-0793-d917-9395-df9de64ed020' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , '0c68bd59-7f9d-c0b9-4e12-e5dc5bb38e7c' , '69e4e5aa-1317-9b5e-0b8b-5417971a9411') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'c436e428-008e-22fe-2019-e84657f43284' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , 'f09e9178-619d-98f1-d563-a1bb3dda4941' , '411adcf8-19af-8c41-c71c-713b3deaa2cb') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '52bcd0d3-7a80-b873-5393-ecc7c734beeb' , '5b8220db-de69-3f44-45f5-c33ff2aa0f0d' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'f74e97d2-ff89-edeb-1134-f21e27ad4188' , '209aa42e-9050-7088-a66f-d6f0cf98e486' , '1763c4e4-2ba7-dc72-4b04-5a8b273dbb6b' , 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '9b85b918-5f3a-4304-9fdb-f43206868fcf' , 'e8bb62bf-44fd-2fa8-d684-9bb39d27c2a4' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'dea35bfd-3e56-456d-9e8f-f6fbc28ba62f' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '0db9a4d1-942b-0bb3-e001-8c04c50b8f8c' , '8da4d055-5b39-3924-23df-1b6d5efa082a') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( '409a250e-9ddb-178b-57e7-fcd4564d4203' , '0969f081-8a2d-cfcc-26bb-9e969311bbf7' , '86a7affa-cc1c-396b-8134-ea6a5b969205' , 'eaac13c0-6dc1-73b9-c20e-cd234fd21f8b') 
GO

INSERT INTO [wfActions] ( [ActionID] , [ActionTypeID] , [StepID] , [NextStepID]) Values( 'cfe6b1f4-511a-c2e0-879f-ff3ee56dcb24' , '3bad2fae-3c62-c154-ec31-260aca17de29' , '402eb3fa-acf0-56ec-be8f-e78d7be5824c' , 'b6b79ebb-af73-8db5-1603-c2f66a8cd1af') 
GO




INSERT INTO [dbo].[wfStepRoles]
select distinct(StepID), N'672bdd8f-71ff-6288-6c8b-554ba481ac32' 
from WfSteps




INSERT INTO [RolesPermissions]
           ([RoleID]
           ,[PermissionID])
     select
           '672bdd8f-71ff-6288-6c8b-554ba481ac32',
           permissionid from permissions;
           
INSERT INTO [Projects]
           ([ProjectID]
           ,[ProjectName]
           ,[ProfitPercent]
           ,[ParentID])
     VALUES
           ('00000000-0000-0000-1111-000000000000',
           N'الحد من الفقر',
           10,
           null);

INSERT INTO [Projects]
           ([ProjectID]
           ,[ProjectName]
           ,[ProfitPercent]
           ,[ParentID])
     VALUES
           ('00000000-0000-1111-0000-000000000000',
           N'الغد الأفضل المشرق',
           15,
           '00000000-0000-0000-1111-000000000000');


INSERT INTO dbo.Users (
	UserID,
	Username,
	Password,
	DisplayName,
	Birthdate,
	JobTitle,
	Email
) VALUES ( 
	'00000000-0000-0000-1111-000000000000',
	N'TestUser',
	N'pass',
	N'Test User',
	'3-10-1988',
	N'Test',
	N'TestUser@quadzdev.com'
	)

INSERT INTO dbo.UsersProjects (
	UserID,
	ProjectID
	)
VALUES ( 
	'00000000-0000-0000-1111-000000000000',
	'00000000-0000-0000-1111-000000000000'
	)




INSERT INTO [UsersRoles]
           ([UserID]
           ,[RoleID])
     select
           '00000000-0000-0000-1111-000000000000',
           roleid from roles;




INSERT INTO [ProjectStages]
           ([ProjectStageID]
           ,[ProjectID]
           ,[Stage]
           ,[AgeLimit]
           ,[From]
           ,[To])
     VALUES
           ('00000000-0000-0000-0000-110000000000'
           ,'00000000-0000-0000-1111-000000000000'
           ,1
           ,20
           ,1000
           ,2000);

INSERT INTO [ProjectStages]
           ([ProjectStageID]
           ,[ProjectID]
           ,[Stage]
           ,[AgeLimit]
           ,[From]
           ,[To])
     VALUES
           ('00000000-0000-0000-0000-110011000000'
           ,'00000000-0000-0000-1111-000000000000'
           ,2
           ,25
           ,2000
           ,5000);

INSERT INTO [ProjectStages]
           ([ProjectStageID]
           ,[ProjectID]
           ,[Stage]
           ,[AgeLimit]
           ,[From]
           ,[To])
     VALUES
           ('00000000-0000-0000-0000-110011001100'
           ,'00000000-0000-1111-0000-000000000000'
           ,3
           ,27
           ,5500
           ,10000);

INSERT INTO [ProjectStages]
           ([ProjectStageID]
           ,[ProjectID]
           ,[Stage]
           ,[AgeLimit]
           ,[From]
           ,[To])
     VALUES
           ('00000000-0000-0000-0000-110011001122'
           ,'00000000-0000-1111-0000-000000000000'
           ,4
           ,30
           ,10000
           ,15000);
           
           
/* end test workflow    */
